Makers of these cells go out all these different text based functions.
We've been talking about functions that will extract data left right and mid able to pull data out using
the length function to return the number of characters to mix and then a little more dynamic using search
to find some then with in it an existing value.
Well now we're going take a look at a function that will combine values.
It's called concatenates you're going to concatenate or combine two or more up to 255 text values together
.
Take a look.
So I got the example file open.
I'm on the work she called concatenate and in here I got a simple little list last name first names
to separate columns B column C column and for the most part when you have a last name and first name
.
A properly designed list says to put them in separate columns because this way you can work with the
data independently sort it filter it do whatever you like with it.
But occasionally you're going to want to combine these two values together into one cell.
Perhaps you're creating mailing labels you're creating some fancy report whenever it might be.
But I want to combine these values together well to do this.
You've actually got multiple ways to do it.
We're going take a look at a very common feature here called the concatenate function.
Watch this and it's really simple.
I'm going to click right below Howard Smet the example there.
This is cell E-4 I'll go back to formulas back to texts and I'm going to find concatenates.
All right.
And it's a really simple one wants to know two things.
At least the folds but you can have up to 255 things essentially just wants to know the text that you
want to combine.
So for me I want to combine Joe and Gonzales.
So for text 1 I'm to grab Joe which is inside a cell.
See for text 2.
I'm not going to do Gonzalez yet.
Yes.
Because I want to say Joe space Gonzales.
They put a space character in there.
So here I'm just going to quote space quote on a combined Joe with the space and then text 3.
I want to combine this with Gonzales and that's it.
I'm just telling it the various pieces that I want to combine together.
Joe with a space with Gonzales and that's it.
OK.
And there we have it combining two or more.
Up to 255 values together into one cell.
Try this out.
And when you're all done you get a feel for it.
Just try it the rest of those names.
Gail Scott Cheryl Kane Kendric shops.
Try it out.
Get all those names combined